package com.xyz.entity.pojo;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class EquipmentInfoExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public EquipmentInfoExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Long value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Long value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Long value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Long value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Long value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Long value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Long> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Long> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Long value1, Long value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Long value1, Long value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andEmNameIsNull() {
            addCriterion("em_name is null");
            return (Criteria) this;
        }

        public Criteria andEmNameIsNotNull() {
            addCriterion("em_name is not null");
            return (Criteria) this;
        }

        public Criteria andEmNameEqualTo(String value) {
            addCriterion("em_name =", value, "emName");
            return (Criteria) this;
        }

        public Criteria andEmNameNotEqualTo(String value) {
            addCriterion("em_name <>", value, "emName");
            return (Criteria) this;
        }

        public Criteria andEmNameGreaterThan(String value) {
            addCriterion("em_name >", value, "emName");
            return (Criteria) this;
        }

        public Criteria andEmNameGreaterThanOrEqualTo(String value) {
            addCriterion("em_name >=", value, "emName");
            return (Criteria) this;
        }

        public Criteria andEmNameLessThan(String value) {
            addCriterion("em_name <", value, "emName");
            return (Criteria) this;
        }

        public Criteria andEmNameLessThanOrEqualTo(String value) {
            addCriterion("em_name <=", value, "emName");
            return (Criteria) this;
        }

        public Criteria andEmNameLike(String value) {
            addCriterion("em_name like", value, "emName");
            return (Criteria) this;
        }

        public Criteria andEmNameNotLike(String value) {
            addCriterion("em_name not like", value, "emName");
            return (Criteria) this;
        }

        public Criteria andEmNameIn(List<String> values) {
            addCriterion("em_name in", values, "emName");
            return (Criteria) this;
        }

        public Criteria andEmNameNotIn(List<String> values) {
            addCriterion("em_name not in", values, "emName");
            return (Criteria) this;
        }

        public Criteria andEmNameBetween(String value1, String value2) {
            addCriterion("em_name between", value1, value2, "emName");
            return (Criteria) this;
        }

        public Criteria andEmNameNotBetween(String value1, String value2) {
            addCriterion("em_name not between", value1, value2, "emName");
            return (Criteria) this;
        }

        public Criteria andEmCodeIsNull() {
            addCriterion("em_code is null");
            return (Criteria) this;
        }

        public Criteria andEmCodeIsNotNull() {
            addCriterion("em_code is not null");
            return (Criteria) this;
        }

        public Criteria andEmCodeEqualTo(String value) {
            addCriterion("em_code =", value, "emCode");
            return (Criteria) this;
        }

        public Criteria andEmCodeNotEqualTo(String value) {
            addCriterion("em_code <>", value, "emCode");
            return (Criteria) this;
        }

        public Criteria andEmCodeGreaterThan(String value) {
            addCriterion("em_code >", value, "emCode");
            return (Criteria) this;
        }

        public Criteria andEmCodeGreaterThanOrEqualTo(String value) {
            addCriterion("em_code >=", value, "emCode");
            return (Criteria) this;
        }

        public Criteria andEmCodeLessThan(String value) {
            addCriterion("em_code <", value, "emCode");
            return (Criteria) this;
        }

        public Criteria andEmCodeLessThanOrEqualTo(String value) {
            addCriterion("em_code <=", value, "emCode");
            return (Criteria) this;
        }

        public Criteria andEmCodeLike(String value) {
            addCriterion("em_code like", value, "emCode");
            return (Criteria) this;
        }

        public Criteria andEmCodeNotLike(String value) {
            addCriterion("em_code not like", value, "emCode");
            return (Criteria) this;
        }

        public Criteria andEmCodeIn(List<String> values) {
            addCriterion("em_code in", values, "emCode");
            return (Criteria) this;
        }

        public Criteria andEmCodeNotIn(List<String> values) {
            addCriterion("em_code not in", values, "emCode");
            return (Criteria) this;
        }

        public Criteria andEmCodeBetween(String value1, String value2) {
            addCriterion("em_code between", value1, value2, "emCode");
            return (Criteria) this;
        }

        public Criteria andEmCodeNotBetween(String value1, String value2) {
            addCriterion("em_code not between", value1, value2, "emCode");
            return (Criteria) this;
        }

        public Criteria andArchiveCodeIsNull() {
            addCriterion("archive_code is null");
            return (Criteria) this;
        }

        public Criteria andArchiveCodeIsNotNull() {
            addCriterion("archive_code is not null");
            return (Criteria) this;
        }

        public Criteria andArchiveCodeEqualTo(String value) {
            addCriterion("archive_code =", value, "archiveCode");
            return (Criteria) this;
        }

        public Criteria andArchiveCodeNotEqualTo(String value) {
            addCriterion("archive_code <>", value, "archiveCode");
            return (Criteria) this;
        }

        public Criteria andArchiveCodeGreaterThan(String value) {
            addCriterion("archive_code >", value, "archiveCode");
            return (Criteria) this;
        }

        public Criteria andArchiveCodeGreaterThanOrEqualTo(String value) {
            addCriterion("archive_code >=", value, "archiveCode");
            return (Criteria) this;
        }

        public Criteria andArchiveCodeLessThan(String value) {
            addCriterion("archive_code <", value, "archiveCode");
            return (Criteria) this;
        }

        public Criteria andArchiveCodeLessThanOrEqualTo(String value) {
            addCriterion("archive_code <=", value, "archiveCode");
            return (Criteria) this;
        }

        public Criteria andArchiveCodeLike(String value) {
            addCriterion("archive_code like", value, "archiveCode");
            return (Criteria) this;
        }

        public Criteria andArchiveCodeNotLike(String value) {
            addCriterion("archive_code not like", value, "archiveCode");
            return (Criteria) this;
        }

        public Criteria andArchiveCodeIn(List<String> values) {
            addCriterion("archive_code in", values, "archiveCode");
            return (Criteria) this;
        }

        public Criteria andArchiveCodeNotIn(List<String> values) {
            addCriterion("archive_code not in", values, "archiveCode");
            return (Criteria) this;
        }

        public Criteria andArchiveCodeBetween(String value1, String value2) {
            addCriterion("archive_code between", value1, value2, "archiveCode");
            return (Criteria) this;
        }

        public Criteria andArchiveCodeNotBetween(String value1, String value2) {
            addCriterion("archive_code not between", value1, value2, "archiveCode");
            return (Criteria) this;
        }

        public Criteria andAssetCodeIsNull() {
            addCriterion("asset_code is null");
            return (Criteria) this;
        }

        public Criteria andAssetCodeIsNotNull() {
            addCriterion("asset_code is not null");
            return (Criteria) this;
        }

        public Criteria andAssetCodeEqualTo(String value) {
            addCriterion("asset_code =", value, "assetCode");
            return (Criteria) this;
        }

        public Criteria andAssetCodeNotEqualTo(String value) {
            addCriterion("asset_code <>", value, "assetCode");
            return (Criteria) this;
        }

        public Criteria andAssetCodeGreaterThan(String value) {
            addCriterion("asset_code >", value, "assetCode");
            return (Criteria) this;
        }

        public Criteria andAssetCodeGreaterThanOrEqualTo(String value) {
            addCriterion("asset_code >=", value, "assetCode");
            return (Criteria) this;
        }

        public Criteria andAssetCodeLessThan(String value) {
            addCriterion("asset_code <", value, "assetCode");
            return (Criteria) this;
        }

        public Criteria andAssetCodeLessThanOrEqualTo(String value) {
            addCriterion("asset_code <=", value, "assetCode");
            return (Criteria) this;
        }

        public Criteria andAssetCodeLike(String value) {
            addCriterion("asset_code like", value, "assetCode");
            return (Criteria) this;
        }

        public Criteria andAssetCodeNotLike(String value) {
            addCriterion("asset_code not like", value, "assetCode");
            return (Criteria) this;
        }

        public Criteria andAssetCodeIn(List<String> values) {
            addCriterion("asset_code in", values, "assetCode");
            return (Criteria) this;
        }

        public Criteria andAssetCodeNotIn(List<String> values) {
            addCriterion("asset_code not in", values, "assetCode");
            return (Criteria) this;
        }

        public Criteria andAssetCodeBetween(String value1, String value2) {
            addCriterion("asset_code between", value1, value2, "assetCode");
            return (Criteria) this;
        }

        public Criteria andAssetCodeNotBetween(String value1, String value2) {
            addCriterion("asset_code not between", value1, value2, "assetCode");
            return (Criteria) this;
        }

        public Criteria andDataCodeIsNull() {
            addCriterion("data_code is null");
            return (Criteria) this;
        }

        public Criteria andDataCodeIsNotNull() {
            addCriterion("data_code is not null");
            return (Criteria) this;
        }

        public Criteria andDataCodeEqualTo(String value) {
            addCriterion("data_code =", value, "dataCode");
            return (Criteria) this;
        }

        public Criteria andDataCodeNotEqualTo(String value) {
            addCriterion("data_code <>", value, "dataCode");
            return (Criteria) this;
        }

        public Criteria andDataCodeGreaterThan(String value) {
            addCriterion("data_code >", value, "dataCode");
            return (Criteria) this;
        }

        public Criteria andDataCodeGreaterThanOrEqualTo(String value) {
            addCriterion("data_code >=", value, "dataCode");
            return (Criteria) this;
        }

        public Criteria andDataCodeLessThan(String value) {
            addCriterion("data_code <", value, "dataCode");
            return (Criteria) this;
        }

        public Criteria andDataCodeLessThanOrEqualTo(String value) {
            addCriterion("data_code <=", value, "dataCode");
            return (Criteria) this;
        }

        public Criteria andDataCodeLike(String value) {
            addCriterion("data_code like", value, "dataCode");
            return (Criteria) this;
        }

        public Criteria andDataCodeNotLike(String value) {
            addCriterion("data_code not like", value, "dataCode");
            return (Criteria) this;
        }

        public Criteria andDataCodeIn(List<String> values) {
            addCriterion("data_code in", values, "dataCode");
            return (Criteria) this;
        }

        public Criteria andDataCodeNotIn(List<String> values) {
            addCriterion("data_code not in", values, "dataCode");
            return (Criteria) this;
        }

        public Criteria andDataCodeBetween(String value1, String value2) {
            addCriterion("data_code between", value1, value2, "dataCode");
            return (Criteria) this;
        }

        public Criteria andDataCodeNotBetween(String value1, String value2) {
            addCriterion("data_code not between", value1, value2, "dataCode");
            return (Criteria) this;
        }

        public Criteria andFactoryCodeIsNull() {
            addCriterion("factory_code is null");
            return (Criteria) this;
        }

        public Criteria andFactoryCodeIsNotNull() {
            addCriterion("factory_code is not null");
            return (Criteria) this;
        }

        public Criteria andFactoryCodeEqualTo(String value) {
            addCriterion("factory_code =", value, "factoryCode");
            return (Criteria) this;
        }

        public Criteria andFactoryCodeNotEqualTo(String value) {
            addCriterion("factory_code <>", value, "factoryCode");
            return (Criteria) this;
        }

        public Criteria andFactoryCodeGreaterThan(String value) {
            addCriterion("factory_code >", value, "factoryCode");
            return (Criteria) this;
        }

        public Criteria andFactoryCodeGreaterThanOrEqualTo(String value) {
            addCriterion("factory_code >=", value, "factoryCode");
            return (Criteria) this;
        }

        public Criteria andFactoryCodeLessThan(String value) {
            addCriterion("factory_code <", value, "factoryCode");
            return (Criteria) this;
        }

        public Criteria andFactoryCodeLessThanOrEqualTo(String value) {
            addCriterion("factory_code <=", value, "factoryCode");
            return (Criteria) this;
        }

        public Criteria andFactoryCodeLike(String value) {
            addCriterion("factory_code like", value, "factoryCode");
            return (Criteria) this;
        }

        public Criteria andFactoryCodeNotLike(String value) {
            addCriterion("factory_code not like", value, "factoryCode");
            return (Criteria) this;
        }

        public Criteria andFactoryCodeIn(List<String> values) {
            addCriterion("factory_code in", values, "factoryCode");
            return (Criteria) this;
        }

        public Criteria andFactoryCodeNotIn(List<String> values) {
            addCriterion("factory_code not in", values, "factoryCode");
            return (Criteria) this;
        }

        public Criteria andFactoryCodeBetween(String value1, String value2) {
            addCriterion("factory_code between", value1, value2, "factoryCode");
            return (Criteria) this;
        }

        public Criteria andFactoryCodeNotBetween(String value1, String value2) {
            addCriterion("factory_code not between", value1, value2, "factoryCode");
            return (Criteria) this;
        }

        public Criteria andEmGradeIsNull() {
            addCriterion("em_grade is null");
            return (Criteria) this;
        }

        public Criteria andEmGradeIsNotNull() {
            addCriterion("em_grade is not null");
            return (Criteria) this;
        }

        public Criteria andEmGradeEqualTo(Integer value) {
            addCriterion("em_grade =", value, "emGrade");
            return (Criteria) this;
        }

        public Criteria andEmGradeNotEqualTo(Integer value) {
            addCriterion("em_grade <>", value, "emGrade");
            return (Criteria) this;
        }

        public Criteria andEmGradeGreaterThan(Integer value) {
            addCriterion("em_grade >", value, "emGrade");
            return (Criteria) this;
        }

        public Criteria andEmGradeGreaterThanOrEqualTo(Integer value) {
            addCriterion("em_grade >=", value, "emGrade");
            return (Criteria) this;
        }

        public Criteria andEmGradeLessThan(Integer value) {
            addCriterion("em_grade <", value, "emGrade");
            return (Criteria) this;
        }

        public Criteria andEmGradeLessThanOrEqualTo(Integer value) {
            addCriterion("em_grade <=", value, "emGrade");
            return (Criteria) this;
        }

        public Criteria andEmGradeIn(List<Integer> values) {
            addCriterion("em_grade in", values, "emGrade");
            return (Criteria) this;
        }

        public Criteria andEmGradeNotIn(List<Integer> values) {
            addCriterion("em_grade not in", values, "emGrade");
            return (Criteria) this;
        }

        public Criteria andEmGradeBetween(Integer value1, Integer value2) {
            addCriterion("em_grade between", value1, value2, "emGrade");
            return (Criteria) this;
        }

        public Criteria andEmGradeNotBetween(Integer value1, Integer value2) {
            addCriterion("em_grade not between", value1, value2, "emGrade");
            return (Criteria) this;
        }

        public Criteria andEmSpecificationIsNull() {
            addCriterion("em_specification is null");
            return (Criteria) this;
        }

        public Criteria andEmSpecificationIsNotNull() {
            addCriterion("em_specification is not null");
            return (Criteria) this;
        }

        public Criteria andEmSpecificationEqualTo(String value) {
            addCriterion("em_specification =", value, "emSpecification");
            return (Criteria) this;
        }

        public Criteria andEmSpecificationNotEqualTo(String value) {
            addCriterion("em_specification <>", value, "emSpecification");
            return (Criteria) this;
        }

        public Criteria andEmSpecificationGreaterThan(String value) {
            addCriterion("em_specification >", value, "emSpecification");
            return (Criteria) this;
        }

        public Criteria andEmSpecificationGreaterThanOrEqualTo(String value) {
            addCriterion("em_specification >=", value, "emSpecification");
            return (Criteria) this;
        }

        public Criteria andEmSpecificationLessThan(String value) {
            addCriterion("em_specification <", value, "emSpecification");
            return (Criteria) this;
        }

        public Criteria andEmSpecificationLessThanOrEqualTo(String value) {
            addCriterion("em_specification <=", value, "emSpecification");
            return (Criteria) this;
        }

        public Criteria andEmSpecificationLike(String value) {
            addCriterion("em_specification like", value, "emSpecification");
            return (Criteria) this;
        }

        public Criteria andEmSpecificationNotLike(String value) {
            addCriterion("em_specification not like", value, "emSpecification");
            return (Criteria) this;
        }

        public Criteria andEmSpecificationIn(List<String> values) {
            addCriterion("em_specification in", values, "emSpecification");
            return (Criteria) this;
        }

        public Criteria andEmSpecificationNotIn(List<String> values) {
            addCriterion("em_specification not in", values, "emSpecification");
            return (Criteria) this;
        }

        public Criteria andEmSpecificationBetween(String value1, String value2) {
            addCriterion("em_specification between", value1, value2, "emSpecification");
            return (Criteria) this;
        }

        public Criteria andEmSpecificationNotBetween(String value1, String value2) {
            addCriterion("em_specification not between", value1, value2, "emSpecification");
            return (Criteria) this;
        }

        public Criteria andMainParameterIsNull() {
            addCriterion("main_parameter is null");
            return (Criteria) this;
        }

        public Criteria andMainParameterIsNotNull() {
            addCriterion("main_parameter is not null");
            return (Criteria) this;
        }

        public Criteria andMainParameterEqualTo(String value) {
            addCriterion("main_parameter =", value, "mainParameter");
            return (Criteria) this;
        }

        public Criteria andMainParameterNotEqualTo(String value) {
            addCriterion("main_parameter <>", value, "mainParameter");
            return (Criteria) this;
        }

        public Criteria andMainParameterGreaterThan(String value) {
            addCriterion("main_parameter >", value, "mainParameter");
            return (Criteria) this;
        }

        public Criteria andMainParameterGreaterThanOrEqualTo(String value) {
            addCriterion("main_parameter >=", value, "mainParameter");
            return (Criteria) this;
        }

        public Criteria andMainParameterLessThan(String value) {
            addCriterion("main_parameter <", value, "mainParameter");
            return (Criteria) this;
        }

        public Criteria andMainParameterLessThanOrEqualTo(String value) {
            addCriterion("main_parameter <=", value, "mainParameter");
            return (Criteria) this;
        }

        public Criteria andMainParameterLike(String value) {
            addCriterion("main_parameter like", value, "mainParameter");
            return (Criteria) this;
        }

        public Criteria andMainParameterNotLike(String value) {
            addCriterion("main_parameter not like", value, "mainParameter");
            return (Criteria) this;
        }

        public Criteria andMainParameterIn(List<String> values) {
            addCriterion("main_parameter in", values, "mainParameter");
            return (Criteria) this;
        }

        public Criteria andMainParameterNotIn(List<String> values) {
            addCriterion("main_parameter not in", values, "mainParameter");
            return (Criteria) this;
        }

        public Criteria andMainParameterBetween(String value1, String value2) {
            addCriterion("main_parameter between", value1, value2, "mainParameter");
            return (Criteria) this;
        }

        public Criteria andMainParameterNotBetween(String value1, String value2) {
            addCriterion("main_parameter not between", value1, value2, "mainParameter");
            return (Criteria) this;
        }

        public Criteria andEmLocationIsNull() {
            addCriterion("em_location is null");
            return (Criteria) this;
        }

        public Criteria andEmLocationIsNotNull() {
            addCriterion("em_location is not null");
            return (Criteria) this;
        }

        public Criteria andEmLocationEqualTo(String value) {
            addCriterion("em_location =", value, "emLocation");
            return (Criteria) this;
        }

        public Criteria andEmLocationNotEqualTo(String value) {
            addCriterion("em_location <>", value, "emLocation");
            return (Criteria) this;
        }

        public Criteria andEmLocationGreaterThan(String value) {
            addCriterion("em_location >", value, "emLocation");
            return (Criteria) this;
        }

        public Criteria andEmLocationGreaterThanOrEqualTo(String value) {
            addCriterion("em_location >=", value, "emLocation");
            return (Criteria) this;
        }

        public Criteria andEmLocationLessThan(String value) {
            addCriterion("em_location <", value, "emLocation");
            return (Criteria) this;
        }

        public Criteria andEmLocationLessThanOrEqualTo(String value) {
            addCriterion("em_location <=", value, "emLocation");
            return (Criteria) this;
        }

        public Criteria andEmLocationLike(String value) {
            addCriterion("em_location like", value, "emLocation");
            return (Criteria) this;
        }

        public Criteria andEmLocationNotLike(String value) {
            addCriterion("em_location not like", value, "emLocation");
            return (Criteria) this;
        }

        public Criteria andEmLocationIn(List<String> values) {
            addCriterion("em_location in", values, "emLocation");
            return (Criteria) this;
        }

        public Criteria andEmLocationNotIn(List<String> values) {
            addCriterion("em_location not in", values, "emLocation");
            return (Criteria) this;
        }

        public Criteria andEmLocationBetween(String value1, String value2) {
            addCriterion("em_location between", value1, value2, "emLocation");
            return (Criteria) this;
        }

        public Criteria andEmLocationNotBetween(String value1, String value2) {
            addCriterion("em_location not between", value1, value2, "emLocation");
            return (Criteria) this;
        }

        public Criteria andEmTreeIsNull() {
            addCriterion("em_tree is null");
            return (Criteria) this;
        }

        public Criteria andEmTreeIsNotNull() {
            addCriterion("em_tree is not null");
            return (Criteria) this;
        }

        public Criteria andEmTreeEqualTo(Long value) {
            addCriterion("em_tree =", value, "emTree");
            return (Criteria) this;
        }

        public Criteria andEmTreeNotEqualTo(Long value) {
            addCriterion("em_tree <>", value, "emTree");
            return (Criteria) this;
        }

        public Criteria andEmTreeGreaterThan(Long value) {
            addCriterion("em_tree >", value, "emTree");
            return (Criteria) this;
        }

        public Criteria andEmTreeGreaterThanOrEqualTo(Long value) {
            addCriterion("em_tree >=", value, "emTree");
            return (Criteria) this;
        }

        public Criteria andEmTreeLessThan(Long value) {
            addCriterion("em_tree <", value, "emTree");
            return (Criteria) this;
        }

        public Criteria andEmTreeLessThanOrEqualTo(Long value) {
            addCriterion("em_tree <=", value, "emTree");
            return (Criteria) this;
        }

        public Criteria andEmTreeIn(List<Long> values) {
            addCriterion("em_tree in", values, "emTree");
            return (Criteria) this;
        }

        public Criteria andEmTreeNotIn(List<Long> values) {
            addCriterion("em_tree not in", values, "emTree");
            return (Criteria) this;
        }

        public Criteria andEmTreeBetween(Long value1, Long value2) {
            addCriterion("em_tree between", value1, value2, "emTree");
            return (Criteria) this;
        }

        public Criteria andEmTreeNotBetween(Long value1, Long value2) {
            addCriterion("em_tree not between", value1, value2, "emTree");
            return (Criteria) this;
        }

        public Criteria andSubTreeIdIsNull() {
            addCriterion("sub_tree_id is null");
            return (Criteria) this;
        }

        public Criteria andSubTreeIdIsNotNull() {
            addCriterion("sub_tree_id is not null");
            return (Criteria) this;
        }

        public Criteria andSubTreeIdEqualTo(Long value) {
            addCriterion("sub_tree_id =", value, "subTreeId");
            return (Criteria) this;
        }

        public Criteria andSubTreeIdNotEqualTo(Long value) {
            addCriterion("sub_tree_id <>", value, "subTreeId");
            return (Criteria) this;
        }

        public Criteria andSubTreeIdGreaterThan(Long value) {
            addCriterion("sub_tree_id >", value, "subTreeId");
            return (Criteria) this;
        }

        public Criteria andSubTreeIdGreaterThanOrEqualTo(Long value) {
            addCriterion("sub_tree_id >=", value, "subTreeId");
            return (Criteria) this;
        }

        public Criteria andSubTreeIdLessThan(Long value) {
            addCriterion("sub_tree_id <", value, "subTreeId");
            return (Criteria) this;
        }

        public Criteria andSubTreeIdLessThanOrEqualTo(Long value) {
            addCriterion("sub_tree_id <=", value, "subTreeId");
            return (Criteria) this;
        }

        public Criteria andSubTreeIdIn(List<Long> values) {
            addCriterion("sub_tree_id in", values, "subTreeId");
            return (Criteria) this;
        }

        public Criteria andSubTreeIdNotIn(List<Long> values) {
            addCriterion("sub_tree_id not in", values, "subTreeId");
            return (Criteria) this;
        }

        public Criteria andSubTreeIdBetween(Long value1, Long value2) {
            addCriterion("sub_tree_id between", value1, value2, "subTreeId");
            return (Criteria) this;
        }

        public Criteria andSubTreeIdNotBetween(Long value1, Long value2) {
            addCriterion("sub_tree_id not between", value1, value2, "subTreeId");
            return (Criteria) this;
        }

        public Criteria andEmTypeIsNull() {
            addCriterion("em_type is null");
            return (Criteria) this;
        }

        public Criteria andEmTypeIsNotNull() {
            addCriterion("em_type is not null");
            return (Criteria) this;
        }

        public Criteria andEmTypeEqualTo(Integer value) {
            addCriterion("em_type =", value, "emType");
            return (Criteria) this;
        }

        public Criteria andEmTypeNotEqualTo(Integer value) {
            addCriterion("em_type <>", value, "emType");
            return (Criteria) this;
        }

        public Criteria andEmTypeGreaterThan(Integer value) {
            addCriterion("em_type >", value, "emType");
            return (Criteria) this;
        }

        public Criteria andEmTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("em_type >=", value, "emType");
            return (Criteria) this;
        }

        public Criteria andEmTypeLessThan(Integer value) {
            addCriterion("em_type <", value, "emType");
            return (Criteria) this;
        }

        public Criteria andEmTypeLessThanOrEqualTo(Integer value) {
            addCriterion("em_type <=", value, "emType");
            return (Criteria) this;
        }

        public Criteria andEmTypeIn(List<Integer> values) {
            addCriterion("em_type in", values, "emType");
            return (Criteria) this;
        }

        public Criteria andEmTypeNotIn(List<Integer> values) {
            addCriterion("em_type not in", values, "emType");
            return (Criteria) this;
        }

        public Criteria andEmTypeBetween(Integer value1, Integer value2) {
            addCriterion("em_type between", value1, value2, "emType");
            return (Criteria) this;
        }

        public Criteria andEmTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("em_type not between", value1, value2, "emType");
            return (Criteria) this;
        }

        public Criteria andEmStateIsNull() {
            addCriterion("em_state is null");
            return (Criteria) this;
        }

        public Criteria andEmStateIsNotNull() {
            addCriterion("em_state is not null");
            return (Criteria) this;
        }

        public Criteria andEmStateEqualTo(Integer value) {
            addCriterion("em_state =", value, "emState");
            return (Criteria) this;
        }

        public Criteria andEmStateNotEqualTo(Integer value) {
            addCriterion("em_state <>", value, "emState");
            return (Criteria) this;
        }

        public Criteria andEmStateGreaterThan(Integer value) {
            addCriterion("em_state >", value, "emState");
            return (Criteria) this;
        }

        public Criteria andEmStateGreaterThanOrEqualTo(Integer value) {
            addCriterion("em_state >=", value, "emState");
            return (Criteria) this;
        }

        public Criteria andEmStateLessThan(Integer value) {
            addCriterion("em_state <", value, "emState");
            return (Criteria) this;
        }

        public Criteria andEmStateLessThanOrEqualTo(Integer value) {
            addCriterion("em_state <=", value, "emState");
            return (Criteria) this;
        }

        public Criteria andEmStateIn(List<Integer> values) {
            addCriterion("em_state in", values, "emState");
            return (Criteria) this;
        }

        public Criteria andEmStateNotIn(List<Integer> values) {
            addCriterion("em_state not in", values, "emState");
            return (Criteria) this;
        }

        public Criteria andEmStateBetween(Integer value1, Integer value2) {
            addCriterion("em_state between", value1, value2, "emState");
            return (Criteria) this;
        }

        public Criteria andEmStateNotBetween(Integer value1, Integer value2) {
            addCriterion("em_state not between", value1, value2, "emState");
            return (Criteria) this;
        }

        public Criteria andManufacturerIsNull() {
            addCriterion("manufacturer is null");
            return (Criteria) this;
        }

        public Criteria andManufacturerIsNotNull() {
            addCriterion("manufacturer is not null");
            return (Criteria) this;
        }

        public Criteria andManufacturerEqualTo(String value) {
            addCriterion("manufacturer =", value, "manufacturer");
            return (Criteria) this;
        }

        public Criteria andManufacturerNotEqualTo(String value) {
            addCriterion("manufacturer <>", value, "manufacturer");
            return (Criteria) this;
        }

        public Criteria andManufacturerGreaterThan(String value) {
            addCriterion("manufacturer >", value, "manufacturer");
            return (Criteria) this;
        }

        public Criteria andManufacturerGreaterThanOrEqualTo(String value) {
            addCriterion("manufacturer >=", value, "manufacturer");
            return (Criteria) this;
        }

        public Criteria andManufacturerLessThan(String value) {
            addCriterion("manufacturer <", value, "manufacturer");
            return (Criteria) this;
        }

        public Criteria andManufacturerLessThanOrEqualTo(String value) {
            addCriterion("manufacturer <=", value, "manufacturer");
            return (Criteria) this;
        }

        public Criteria andManufacturerLike(String value) {
            addCriterion("manufacturer like", value, "manufacturer");
            return (Criteria) this;
        }

        public Criteria andManufacturerNotLike(String value) {
            addCriterion("manufacturer not like", value, "manufacturer");
            return (Criteria) this;
        }

        public Criteria andManufacturerIn(List<String> values) {
            addCriterion("manufacturer in", values, "manufacturer");
            return (Criteria) this;
        }

        public Criteria andManufacturerNotIn(List<String> values) {
            addCriterion("manufacturer not in", values, "manufacturer");
            return (Criteria) this;
        }

        public Criteria andManufacturerBetween(String value1, String value2) {
            addCriterion("manufacturer between", value1, value2, "manufacturer");
            return (Criteria) this;
        }

        public Criteria andManufacturerNotBetween(String value1, String value2) {
            addCriterion("manufacturer not between", value1, value2, "manufacturer");
            return (Criteria) this;
        }

        public Criteria andUnitIsNull() {
            addCriterion("unit is null");
            return (Criteria) this;
        }

        public Criteria andUnitIsNotNull() {
            addCriterion("unit is not null");
            return (Criteria) this;
        }

        public Criteria andUnitEqualTo(String value) {
            addCriterion("unit =", value, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitNotEqualTo(String value) {
            addCriterion("unit <>", value, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitGreaterThan(String value) {
            addCriterion("unit >", value, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitGreaterThanOrEqualTo(String value) {
            addCriterion("unit >=", value, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitLessThan(String value) {
            addCriterion("unit <", value, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitLessThanOrEqualTo(String value) {
            addCriterion("unit <=", value, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitLike(String value) {
            addCriterion("unit like", value, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitNotLike(String value) {
            addCriterion("unit not like", value, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitIn(List<String> values) {
            addCriterion("unit in", values, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitNotIn(List<String> values) {
            addCriterion("unit not in", values, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitBetween(String value1, String value2) {
            addCriterion("unit between", value1, value2, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitNotBetween(String value1, String value2) {
            addCriterion("unit not between", value1, value2, "unit");
            return (Criteria) this;
        }

        public Criteria andOperationTimeIsNull() {
            addCriterion("operation_time is null");
            return (Criteria) this;
        }

        public Criteria andOperationTimeIsNotNull() {
            addCriterion("operation_time is not null");
            return (Criteria) this;
        }

        public Criteria andOperationTimeEqualTo(Date value) {
            addCriterion("operation_time =", value, "operationTime");
            return (Criteria) this;
        }

        public Criteria andOperationTimeNotEqualTo(Date value) {
            addCriterion("operation_time <>", value, "operationTime");
            return (Criteria) this;
        }

        public Criteria andOperationTimeGreaterThan(Date value) {
            addCriterion("operation_time >", value, "operationTime");
            return (Criteria) this;
        }

        public Criteria andOperationTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("operation_time >=", value, "operationTime");
            return (Criteria) this;
        }

        public Criteria andOperationTimeLessThan(Date value) {
            addCriterion("operation_time <", value, "operationTime");
            return (Criteria) this;
        }

        public Criteria andOperationTimeLessThanOrEqualTo(Date value) {
            addCriterion("operation_time <=", value, "operationTime");
            return (Criteria) this;
        }

        public Criteria andOperationTimeIn(List<Date> values) {
            addCriterion("operation_time in", values, "operationTime");
            return (Criteria) this;
        }

        public Criteria andOperationTimeNotIn(List<Date> values) {
            addCriterion("operation_time not in", values, "operationTime");
            return (Criteria) this;
        }

        public Criteria andOperationTimeBetween(Date value1, Date value2) {
            addCriterion("operation_time between", value1, value2, "operationTime");
            return (Criteria) this;
        }

        public Criteria andOperationTimeNotBetween(Date value1, Date value2) {
            addCriterion("operation_time not between", value1, value2, "operationTime");
            return (Criteria) this;
        }

        public Criteria andPurchaseTimeIsNull() {
            addCriterion("purchase_time is null");
            return (Criteria) this;
        }

        public Criteria andPurchaseTimeIsNotNull() {
            addCriterion("purchase_time is not null");
            return (Criteria) this;
        }

        public Criteria andPurchaseTimeEqualTo(Date value) {
            addCriterion("purchase_time =", value, "purchaseTime");
            return (Criteria) this;
        }

        public Criteria andPurchaseTimeNotEqualTo(Date value) {
            addCriterion("purchase_time <>", value, "purchaseTime");
            return (Criteria) this;
        }

        public Criteria andPurchaseTimeGreaterThan(Date value) {
            addCriterion("purchase_time >", value, "purchaseTime");
            return (Criteria) this;
        }

        public Criteria andPurchaseTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("purchase_time >=", value, "purchaseTime");
            return (Criteria) this;
        }

        public Criteria andPurchaseTimeLessThan(Date value) {
            addCriterion("purchase_time <", value, "purchaseTime");
            return (Criteria) this;
        }

        public Criteria andPurchaseTimeLessThanOrEqualTo(Date value) {
            addCriterion("purchase_time <=", value, "purchaseTime");
            return (Criteria) this;
        }

        public Criteria andPurchaseTimeIn(List<Date> values) {
            addCriterion("purchase_time in", values, "purchaseTime");
            return (Criteria) this;
        }

        public Criteria andPurchaseTimeNotIn(List<Date> values) {
            addCriterion("purchase_time not in", values, "purchaseTime");
            return (Criteria) this;
        }

        public Criteria andPurchaseTimeBetween(Date value1, Date value2) {
            addCriterion("purchase_time between", value1, value2, "purchaseTime");
            return (Criteria) this;
        }

        public Criteria andPurchaseTimeNotBetween(Date value1, Date value2) {
            addCriterion("purchase_time not between", value1, value2, "purchaseTime");
            return (Criteria) this;
        }

        public Criteria andFactoryTimeIsNull() {
            addCriterion("factory_time is null");
            return (Criteria) this;
        }

        public Criteria andFactoryTimeIsNotNull() {
            addCriterion("factory_time is not null");
            return (Criteria) this;
        }

        public Criteria andFactoryTimeEqualTo(Date value) {
            addCriterion("factory_time =", value, "factoryTime");
            return (Criteria) this;
        }

        public Criteria andFactoryTimeNotEqualTo(Date value) {
            addCriterion("factory_time <>", value, "factoryTime");
            return (Criteria) this;
        }

        public Criteria andFactoryTimeGreaterThan(Date value) {
            addCriterion("factory_time >", value, "factoryTime");
            return (Criteria) this;
        }

        public Criteria andFactoryTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("factory_time >=", value, "factoryTime");
            return (Criteria) this;
        }

        public Criteria andFactoryTimeLessThan(Date value) {
            addCriterion("factory_time <", value, "factoryTime");
            return (Criteria) this;
        }

        public Criteria andFactoryTimeLessThanOrEqualTo(Date value) {
            addCriterion("factory_time <=", value, "factoryTime");
            return (Criteria) this;
        }

        public Criteria andFactoryTimeIn(List<Date> values) {
            addCriterion("factory_time in", values, "factoryTime");
            return (Criteria) this;
        }

        public Criteria andFactoryTimeNotIn(List<Date> values) {
            addCriterion("factory_time not in", values, "factoryTime");
            return (Criteria) this;
        }

        public Criteria andFactoryTimeBetween(Date value1, Date value2) {
            addCriterion("factory_time between", value1, value2, "factoryTime");
            return (Criteria) this;
        }

        public Criteria andFactoryTimeNotBetween(Date value1, Date value2) {
            addCriterion("factory_time not between", value1, value2, "factoryTime");
            return (Criteria) this;
        }

        public Criteria andIsProvideIsNull() {
            addCriterion("is_provide is null");
            return (Criteria) this;
        }

        public Criteria andIsProvideIsNotNull() {
            addCriterion("is_provide is not null");
            return (Criteria) this;
        }

        public Criteria andIsProvideEqualTo(Integer value) {
            addCriterion("is_provide =", value, "isProvide");
            return (Criteria) this;
        }

        public Criteria andIsProvideNotEqualTo(Integer value) {
            addCriterion("is_provide <>", value, "isProvide");
            return (Criteria) this;
        }

        public Criteria andIsProvideGreaterThan(Integer value) {
            addCriterion("is_provide >", value, "isProvide");
            return (Criteria) this;
        }

        public Criteria andIsProvideGreaterThanOrEqualTo(Integer value) {
            addCriterion("is_provide >=", value, "isProvide");
            return (Criteria) this;
        }

        public Criteria andIsProvideLessThan(Integer value) {
            addCriterion("is_provide <", value, "isProvide");
            return (Criteria) this;
        }

        public Criteria andIsProvideLessThanOrEqualTo(Integer value) {
            addCriterion("is_provide <=", value, "isProvide");
            return (Criteria) this;
        }

        public Criteria andIsProvideIn(List<Integer> values) {
            addCriterion("is_provide in", values, "isProvide");
            return (Criteria) this;
        }

        public Criteria andIsProvideNotIn(List<Integer> values) {
            addCriterion("is_provide not in", values, "isProvide");
            return (Criteria) this;
        }

        public Criteria andIsProvideBetween(Integer value1, Integer value2) {
            addCriterion("is_provide between", value1, value2, "isProvide");
            return (Criteria) this;
        }

        public Criteria andIsProvideNotBetween(Integer value1, Integer value2) {
            addCriterion("is_provide not between", value1, value2, "isProvide");
            return (Criteria) this;
        }

        public Criteria andIsSpecialIsNull() {
            addCriterion("is_special is null");
            return (Criteria) this;
        }

        public Criteria andIsSpecialIsNotNull() {
            addCriterion("is_special is not null");
            return (Criteria) this;
        }

        public Criteria andIsSpecialEqualTo(Integer value) {
            addCriterion("is_special =", value, "isSpecial");
            return (Criteria) this;
        }

        public Criteria andIsSpecialNotEqualTo(Integer value) {
            addCriterion("is_special <>", value, "isSpecial");
            return (Criteria) this;
        }

        public Criteria andIsSpecialGreaterThan(Integer value) {
            addCriterion("is_special >", value, "isSpecial");
            return (Criteria) this;
        }

        public Criteria andIsSpecialGreaterThanOrEqualTo(Integer value) {
            addCriterion("is_special >=", value, "isSpecial");
            return (Criteria) this;
        }

        public Criteria andIsSpecialLessThan(Integer value) {
            addCriterion("is_special <", value, "isSpecial");
            return (Criteria) this;
        }

        public Criteria andIsSpecialLessThanOrEqualTo(Integer value) {
            addCriterion("is_special <=", value, "isSpecial");
            return (Criteria) this;
        }

        public Criteria andIsSpecialIn(List<Integer> values) {
            addCriterion("is_special in", values, "isSpecial");
            return (Criteria) this;
        }

        public Criteria andIsSpecialNotIn(List<Integer> values) {
            addCriterion("is_special not in", values, "isSpecial");
            return (Criteria) this;
        }

        public Criteria andIsSpecialBetween(Integer value1, Integer value2) {
            addCriterion("is_special between", value1, value2, "isSpecial");
            return (Criteria) this;
        }

        public Criteria andIsSpecialNotBetween(Integer value1, Integer value2) {
            addCriterion("is_special not between", value1, value2, "isSpecial");
            return (Criteria) this;
        }

        public Criteria andSpecialNextTimeIsNull() {
            addCriterion("special_next_time is null");
            return (Criteria) this;
        }

        public Criteria andSpecialNextTimeIsNotNull() {
            addCriterion("special_next_time is not null");
            return (Criteria) this;
        }

        public Criteria andSpecialNextTimeEqualTo(Date value) {
            addCriterion("special_next_time =", value, "specialNextTime");
            return (Criteria) this;
        }

        public Criteria andSpecialNextTimeNotEqualTo(Date value) {
            addCriterion("special_next_time <>", value, "specialNextTime");
            return (Criteria) this;
        }

        public Criteria andSpecialNextTimeGreaterThan(Date value) {
            addCriterion("special_next_time >", value, "specialNextTime");
            return (Criteria) this;
        }

        public Criteria andSpecialNextTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("special_next_time >=", value, "specialNextTime");
            return (Criteria) this;
        }

        public Criteria andSpecialNextTimeLessThan(Date value) {
            addCriterion("special_next_time <", value, "specialNextTime");
            return (Criteria) this;
        }

        public Criteria andSpecialNextTimeLessThanOrEqualTo(Date value) {
            addCriterion("special_next_time <=", value, "specialNextTime");
            return (Criteria) this;
        }

        public Criteria andSpecialNextTimeIn(List<Date> values) {
            addCriterion("special_next_time in", values, "specialNextTime");
            return (Criteria) this;
        }

        public Criteria andSpecialNextTimeNotIn(List<Date> values) {
            addCriterion("special_next_time not in", values, "specialNextTime");
            return (Criteria) this;
        }

        public Criteria andSpecialNextTimeBetween(Date value1, Date value2) {
            addCriterion("special_next_time between", value1, value2, "specialNextTime");
            return (Criteria) this;
        }

        public Criteria andSpecialNextTimeNotBetween(Date value1, Date value2) {
            addCriterion("special_next_time not between", value1, value2, "specialNextTime");
            return (Criteria) this;
        }

        public Criteria andAuxiliaryInfoIsNull() {
            addCriterion("auxiliary_info is null");
            return (Criteria) this;
        }

        public Criteria andAuxiliaryInfoIsNotNull() {
            addCriterion("auxiliary_info is not null");
            return (Criteria) this;
        }

        public Criteria andAuxiliaryInfoEqualTo(String value) {
            addCriterion("auxiliary_info =", value, "auxiliaryInfo");
            return (Criteria) this;
        }

        public Criteria andAuxiliaryInfoNotEqualTo(String value) {
            addCriterion("auxiliary_info <>", value, "auxiliaryInfo");
            return (Criteria) this;
        }

        public Criteria andAuxiliaryInfoGreaterThan(String value) {
            addCriterion("auxiliary_info >", value, "auxiliaryInfo");
            return (Criteria) this;
        }

        public Criteria andAuxiliaryInfoGreaterThanOrEqualTo(String value) {
            addCriterion("auxiliary_info >=", value, "auxiliaryInfo");
            return (Criteria) this;
        }

        public Criteria andAuxiliaryInfoLessThan(String value) {
            addCriterion("auxiliary_info <", value, "auxiliaryInfo");
            return (Criteria) this;
        }

        public Criteria andAuxiliaryInfoLessThanOrEqualTo(String value) {
            addCriterion("auxiliary_info <=", value, "auxiliaryInfo");
            return (Criteria) this;
        }

        public Criteria andAuxiliaryInfoLike(String value) {
            addCriterion("auxiliary_info like", value, "auxiliaryInfo");
            return (Criteria) this;
        }

        public Criteria andAuxiliaryInfoNotLike(String value) {
            addCriterion("auxiliary_info not like", value, "auxiliaryInfo");
            return (Criteria) this;
        }

        public Criteria andAuxiliaryInfoIn(List<String> values) {
            addCriterion("auxiliary_info in", values, "auxiliaryInfo");
            return (Criteria) this;
        }

        public Criteria andAuxiliaryInfoNotIn(List<String> values) {
            addCriterion("auxiliary_info not in", values, "auxiliaryInfo");
            return (Criteria) this;
        }

        public Criteria andAuxiliaryInfoBetween(String value1, String value2) {
            addCriterion("auxiliary_info between", value1, value2, "auxiliaryInfo");
            return (Criteria) this;
        }

        public Criteria andAuxiliaryInfoNotBetween(String value1, String value2) {
            addCriterion("auxiliary_info not between", value1, value2, "auxiliaryInfo");
            return (Criteria) this;
        }

        public Criteria andIsScrapIsNull() {
            addCriterion("is_scrap is null");
            return (Criteria) this;
        }

        public Criteria andIsScrapIsNotNull() {
            addCriterion("is_scrap is not null");
            return (Criteria) this;
        }

        public Criteria andIsScrapEqualTo(Integer value) {
            addCriterion("is_scrap =", value, "isScrap");
            return (Criteria) this;
        }

        public Criteria andIsScrapNotEqualTo(Integer value) {
            addCriterion("is_scrap <>", value, "isScrap");
            return (Criteria) this;
        }

        public Criteria andIsScrapGreaterThan(Integer value) {
            addCriterion("is_scrap >", value, "isScrap");
            return (Criteria) this;
        }

        public Criteria andIsScrapGreaterThanOrEqualTo(Integer value) {
            addCriterion("is_scrap >=", value, "isScrap");
            return (Criteria) this;
        }

        public Criteria andIsScrapLessThan(Integer value) {
            addCriterion("is_scrap <", value, "isScrap");
            return (Criteria) this;
        }

        public Criteria andIsScrapLessThanOrEqualTo(Integer value) {
            addCriterion("is_scrap <=", value, "isScrap");
            return (Criteria) this;
        }

        public Criteria andIsScrapIn(List<Integer> values) {
            addCriterion("is_scrap in", values, "isScrap");
            return (Criteria) this;
        }

        public Criteria andIsScrapNotIn(List<Integer> values) {
            addCriterion("is_scrap not in", values, "isScrap");
            return (Criteria) this;
        }

        public Criteria andIsScrapBetween(Integer value1, Integer value2) {
            addCriterion("is_scrap between", value1, value2, "isScrap");
            return (Criteria) this;
        }

        public Criteria andIsScrapNotBetween(Integer value1, Integer value2) {
            addCriterion("is_scrap not between", value1, value2, "isScrap");
            return (Criteria) this;
        }

        public Criteria andIsElectricalIsNull() {
            addCriterion("is_electrical is null");
            return (Criteria) this;
        }

        public Criteria andIsElectricalIsNotNull() {
            addCriterion("is_electrical is not null");
            return (Criteria) this;
        }

        public Criteria andIsElectricalEqualTo(Integer value) {
            addCriterion("is_electrical =", value, "isElectrical");
            return (Criteria) this;
        }

        public Criteria andIsElectricalNotEqualTo(Integer value) {
            addCriterion("is_electrical <>", value, "isElectrical");
            return (Criteria) this;
        }

        public Criteria andIsElectricalGreaterThan(Integer value) {
            addCriterion("is_electrical >", value, "isElectrical");
            return (Criteria) this;
        }

        public Criteria andIsElectricalGreaterThanOrEqualTo(Integer value) {
            addCriterion("is_electrical >=", value, "isElectrical");
            return (Criteria) this;
        }

        public Criteria andIsElectricalLessThan(Integer value) {
            addCriterion("is_electrical <", value, "isElectrical");
            return (Criteria) this;
        }

        public Criteria andIsElectricalLessThanOrEqualTo(Integer value) {
            addCriterion("is_electrical <=", value, "isElectrical");
            return (Criteria) this;
        }

        public Criteria andIsElectricalIn(List<Integer> values) {
            addCriterion("is_electrical in", values, "isElectrical");
            return (Criteria) this;
        }

        public Criteria andIsElectricalNotIn(List<Integer> values) {
            addCriterion("is_electrical not in", values, "isElectrical");
            return (Criteria) this;
        }

        public Criteria andIsElectricalBetween(Integer value1, Integer value2) {
            addCriterion("is_electrical between", value1, value2, "isElectrical");
            return (Criteria) this;
        }

        public Criteria andIsElectricalNotBetween(Integer value1, Integer value2) {
            addCriterion("is_electrical not between", value1, value2, "isElectrical");
            return (Criteria) this;
        }

        public Criteria andIsDeleteIsNull() {
            addCriterion("is_delete is null");
            return (Criteria) this;
        }

        public Criteria andIsDeleteIsNotNull() {
            addCriterion("is_delete is not null");
            return (Criteria) this;
        }

        public Criteria andIsDeleteEqualTo(Integer value) {
            addCriterion("is_delete =", value, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteNotEqualTo(Integer value) {
            addCriterion("is_delete <>", value, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteGreaterThan(Integer value) {
            addCriterion("is_delete >", value, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteGreaterThanOrEqualTo(Integer value) {
            addCriterion("is_delete >=", value, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteLessThan(Integer value) {
            addCriterion("is_delete <", value, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteLessThanOrEqualTo(Integer value) {
            addCriterion("is_delete <=", value, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteIn(List<Integer> values) {
            addCriterion("is_delete in", values, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteNotIn(List<Integer> values) {
            addCriterion("is_delete not in", values, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteBetween(Integer value1, Integer value2) {
            addCriterion("is_delete between", value1, value2, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteNotBetween(Integer value1, Integer value2) {
            addCriterion("is_delete not between", value1, value2, "isDelete");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNull() {
            addCriterion("create_time is null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
            addCriterion("create_time is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(Date value) {
            addCriterion("create_time =", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(Date value) {
            addCriterion("create_time <>", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(Date value) {
            addCriterion("create_time >", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("create_time >=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(Date value) {
            addCriterion("create_time <", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
            addCriterion("create_time <=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<Date> values) {
            addCriterion("create_time in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<Date> values) {
            addCriterion("create_time not in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(Date value1, Date value2) {
            addCriterion("create_time between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
            addCriterion("create_time not between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateByIsNull() {
            addCriterion("create_by is null");
            return (Criteria) this;
        }

        public Criteria andCreateByIsNotNull() {
            addCriterion("create_by is not null");
            return (Criteria) this;
        }

        public Criteria andCreateByEqualTo(String value) {
            addCriterion("create_by =", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByNotEqualTo(String value) {
            addCriterion("create_by <>", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByGreaterThan(String value) {
            addCriterion("create_by >", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByGreaterThanOrEqualTo(String value) {
            addCriterion("create_by >=", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByLessThan(String value) {
            addCriterion("create_by <", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByLessThanOrEqualTo(String value) {
            addCriterion("create_by <=", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByLike(String value) {
            addCriterion("create_by like", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByNotLike(String value) {
            addCriterion("create_by not like", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByIn(List<String> values) {
            addCriterion("create_by in", values, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByNotIn(List<String> values) {
            addCriterion("create_by not in", values, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByBetween(String value1, String value2) {
            addCriterion("create_by between", value1, value2, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByNotBetween(String value1, String value2) {
            addCriterion("create_by not between", value1, value2, "createBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByIsNull() {
            addCriterion("update_by is null");
            return (Criteria) this;
        }

        public Criteria andUpdateByIsNotNull() {
            addCriterion("update_by is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateByEqualTo(String value) {
            addCriterion("update_by =", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByNotEqualTo(String value) {
            addCriterion("update_by <>", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByGreaterThan(String value) {
            addCriterion("update_by >", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByGreaterThanOrEqualTo(String value) {
            addCriterion("update_by >=", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByLessThan(String value) {
            addCriterion("update_by <", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByLessThanOrEqualTo(String value) {
            addCriterion("update_by <=", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByLike(String value) {
            addCriterion("update_by like", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByNotLike(String value) {
            addCriterion("update_by not like", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByIn(List<String> values) {
            addCriterion("update_by in", values, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByNotIn(List<String> values) {
            addCriterion("update_by not in", values, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByBetween(String value1, String value2) {
            addCriterion("update_by between", value1, value2, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByNotBetween(String value1, String value2) {
            addCriterion("update_by not between", value1, value2, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNull() {
            addCriterion("update_time is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNotNull() {
            addCriterion("update_time is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualTo(Date value) {
            addCriterion("update_time =", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualTo(Date value) {
            addCriterion("update_time <>", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThan(Date value) {
            addCriterion("update_time >", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("update_time >=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThan(Date value) {
            addCriterion("update_time <", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualTo(Date value) {
            addCriterion("update_time <=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIn(List<Date> values) {
            addCriterion("update_time in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotIn(List<Date> values) {
            addCriterion("update_time not in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeBetween(Date value1, Date value2) {
            addCriterion("update_time between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotBetween(Date value1, Date value2) {
            addCriterion("update_time not between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andDelFlagIsNull() {
            addCriterion("del_flag is null");
            return (Criteria) this;
        }

        public Criteria andDelFlagIsNotNull() {
            addCriterion("del_flag is not null");
            return (Criteria) this;
        }

        public Criteria andDelFlagEqualTo(Integer value) {
            addCriterion("del_flag =", value, "delFlag");
            return (Criteria) this;
        }

        public Criteria andDelFlagNotEqualTo(Integer value) {
            addCriterion("del_flag <>", value, "delFlag");
            return (Criteria) this;
        }

        public Criteria andDelFlagGreaterThan(Integer value) {
            addCriterion("del_flag >", value, "delFlag");
            return (Criteria) this;
        }

        public Criteria andDelFlagGreaterThanOrEqualTo(Integer value) {
            addCriterion("del_flag >=", value, "delFlag");
            return (Criteria) this;
        }

        public Criteria andDelFlagLessThan(Integer value) {
            addCriterion("del_flag <", value, "delFlag");
            return (Criteria) this;
        }

        public Criteria andDelFlagLessThanOrEqualTo(Integer value) {
            addCriterion("del_flag <=", value, "delFlag");
            return (Criteria) this;
        }

        public Criteria andDelFlagIn(List<Integer> values) {
            addCriterion("del_flag in", values, "delFlag");
            return (Criteria) this;
        }

        public Criteria andDelFlagNotIn(List<Integer> values) {
            addCriterion("del_flag not in", values, "delFlag");
            return (Criteria) this;
        }

        public Criteria andDelFlagBetween(Integer value1, Integer value2) {
            addCriterion("del_flag between", value1, value2, "delFlag");
            return (Criteria) this;
        }

        public Criteria andDelFlagNotBetween(Integer value1, Integer value2) {
            addCriterion("del_flag not between", value1, value2, "delFlag");
            return (Criteria) this;
        }

        public Criteria andVersionIsNull() {
            addCriterion("version is null");
            return (Criteria) this;
        }

        public Criteria andVersionIsNotNull() {
            addCriterion("version is not null");
            return (Criteria) this;
        }

        public Criteria andVersionEqualTo(Integer value) {
            addCriterion("version =", value, "version");
            return (Criteria) this;
        }

        public Criteria andVersionNotEqualTo(Integer value) {
            addCriterion("version <>", value, "version");
            return (Criteria) this;
        }

        public Criteria andVersionGreaterThan(Integer value) {
            addCriterion("version >", value, "version");
            return (Criteria) this;
        }

        public Criteria andVersionGreaterThanOrEqualTo(Integer value) {
            addCriterion("version >=", value, "version");
            return (Criteria) this;
        }

        public Criteria andVersionLessThan(Integer value) {
            addCriterion("version <", value, "version");
            return (Criteria) this;
        }

        public Criteria andVersionLessThanOrEqualTo(Integer value) {
            addCriterion("version <=", value, "version");
            return (Criteria) this;
        }

        public Criteria andVersionIn(List<Integer> values) {
            addCriterion("version in", values, "version");
            return (Criteria) this;
        }

        public Criteria andVersionNotIn(List<Integer> values) {
            addCriterion("version not in", values, "version");
            return (Criteria) this;
        }

        public Criteria andVersionBetween(Integer value1, Integer value2) {
            addCriterion("version between", value1, value2, "version");
            return (Criteria) this;
        }

        public Criteria andVersionNotBetween(Integer value1, Integer value2) {
            addCriterion("version not between", value1, value2, "version");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}